package com.example.gss.mapper;

import com.example.gss.entity.Competition;
import org.apache.ibatis.annotations.Mapper;

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

/**
 * 学科竞赛Mapper接口
 */
@Mapper
public interface CompetitionMapper {
    int insert(Competition competition);
    int update(Competition competition);
    int deleteById(String competitionId);
    Competition selectById(String competitionId);
    List<Competition> selectAll();
    List<Competition> selectByStudentId(String studentId);
    List<Competition> selectByDateRange(Date startDate, Date endDate);
    BigDecimal calculateTotalScore(String studentId);
}